package com.monitor.dao;

import com.monitor.entity.ErpTpmsTireInformation;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.baomidou.mybatisplus.mapper.BaseMapper;

/**
 * <p>
 * 客户轮胎报警值设置表 Mapper 接口
 * </p>
 *
 * @author LX
 * @since 2018-10-09
 */
public interface ErpTpmsTireInformationMapper extends BaseMapper<ErpTpmsTireInformation> {
	@Select("SELECT * FROM erp_tpms_tire_information WHERE pid=#{cId} ORDER BY id desc LIMIT 0,1")
	public ErpTpmsTireInformation selectByCId(@Param("cId")int cId);
	
	@Update("UPDATE erp_tpms_tire_information SET ${sql}")
	public Integer updateAllCulnm(@Param("sql")String sql);
}
